-- 区县数据新增经纬度字段
ALTER TABLE [dbo].[cup_region] ADD [longitude] nvarchar(255) NULL
    GO

ALTER TABLE [dbo].[cup_region] ADD [latitude] nvarchar(255) NULL
    GO
    EXEC sp_addextendedproperty
    'MS_Description', N'经度',
    'SCHEMA', N'dbo',
    'TABLE', N'cup_region',
    'COLUMN', N'longitude'
    GO
    EXEC sp_addextendedproperty
    'MS_Description', N'纬度',
    'SCHEMA', N'dbo',
    'TABLE', N'cup_region',
    'COLUMN', N'latitude'

update cup_region set longitude='108.380246',latitude='30.807807' where name=N'万州区';
update cup_region set longitude='107.394905',latitude='29.703652' where name=N'涪陵区';
update cup_region set longitude='106.56288',latitude='29.556742' where name=N'渝中区';
update cup_region set longitude='106.48613',latitude='29.481002' where name=N'大渡口区';
update cup_region set longitude='106.532844',latitude='29.575352' where name=N'江北区';
update cup_region set longitude='106.4542',latitude='29.541224' where name=N'沙坪坝区';
update cup_region set longitude='106.480989',latitude='29.523492' where name=N'九龙坡区';
update cup_region set longitude='106.560813',latitude='29.523992' where name=N'南岸区';
update cup_region set longitude='106.437868',latitude='29.82543' where name=N'北碚区';
update cup_region set longitude='106.651417',latitude='29.028091' where name=N'綦江区';
update cup_region set longitude='105.715319',latitude='29.700498' where name=N'大足区';
update cup_region set longitude='106.512851',latitude='29.601451' where name=N'渝北区';
update cup_region set longitude='106.519423',latitude='29.381919' where name=N'巴南区';
update cup_region set longitude='108.782577',latitude='29.527548' where name=N'黔江区';
update cup_region set longitude='107.074854',latitude='29.833671' where name=N'长寿区';
update cup_region set longitude='106.253156',latitude='29.283387' where name=N'江津区';
update cup_region set longitude='106.265554',latitude='29.990993' where name=N'合川区';
update cup_region set longitude='105.894714',latitude='29.348748' where name=N'永川区';
update cup_region set longitude='107.098153',latitude='29.156646' where name=N'南川区';
update cup_region set longitude='106.231126',latitude='29.593581' where name=N'璧山区';
update cup_region set longitude='106.054948',latitude='29.839944' where name=N'铜梁区';
update cup_region set longitude='105.841818',latitude='30.189554' where name=N'潼南区';
update cup_region set longitude='105.594061',latitude='29.403627' where name=N'荣昌区';
update cup_region set longitude='108.413317',latitude='31.167735' where name=N'开州区';
update cup_region set longitude='107.800034',latitude='30.672168' where name=N'梁平区';
update cup_region set longitude='107.75655',latitude='29.32376' where name=N'武隆区';
update cup_region set longitude='108.6649',latitude='31.946293' where name=N'城口县';
update cup_region set longitude='107.73248',latitude='29.866424' where name=N'丰都县';
update cup_region set longitude='107.348692',latitude='30.330012' where name=N'垫江县';
update cup_region set longitude='108.037518',latitude='30.291537' where name=N'忠县';
update cup_region set longitude='108.697698',latitude='30.930529' where name=N'云阳县';
update cup_region set longitude='109.465774',latitude='31.019967' where name=N'奉节县';
update cup_region set longitude='109.878928',latitude='31.074843' where name=N'巫山县';
update cup_region set longitude='109.628912',latitude='31.3966' where name=N'巫溪县';
update cup_region set longitude='108.112448',latitude='29.99853' where name=N'石柱县';
update cup_region set longitude='108.996043',latitude='28.444772' where name=N'秀山县';
update cup_region set longitude='108.767201',latitude='28.839828' where name=N'酉阳县';
update cup_region set longitude='108.166551',latitude='29.293856' where name=N'彭水县';
update cup_region set longitude='106.566022',latitude='29.642726' where name=N'两江新区';
update cup_region set longitude='106.335882',latitude='29.512861' where name=N'高新区';
update cup_region set longitude='105.91',latitude='29.38' where name=N'万盛经开区';
update cup_region set longitude='105.78',latitude='29.48' where name=N'双桥经开区';
update cup_region set longitude='106.552443',latitude='29.576095' where name=N'经开区';


